//
//  DbTable.h
//  MarketDataColloctor
//
//  Created by jiro on 10/03/10.
//  Copyright 2010 jiro music. All rights reserved.
//

#import <Cocoa/Cocoa.h>
#import "../Nodes.h"

@interface DbTableEntry_ : NSObject
{

}


- (NSString*) sqlInsertStatement;	//	deprecated

+ (NSString*) tableName;

+ (int) dataCountWithTableName: (NSString*) tableName andWhereClause: (WhereNode*) condition;

+ (NSString*) queryCreateTable;
+ (NSString*) queryFieldsOfCreateTable;

+ (NSString*) queryInsertInitialValues;
- (NSString*) queryInsert;
- (NSString*) queryInsertValue;

+ (NSString*) querySelectAll;

+ (NSString*) querySelectAllWithClauses: (NSArray*) clauses;
+ (NSString*) querySelectAllWithTableName: (NSString*) tableName andClauses: (NSArray*) clauses;

+ (NSString*) querySelectFields: (NSArray*) fieldNodes andClauses: (NSArray*) clauses;
+ (NSString*) querySelectFields: (NSArray*) fieldNodes tableName: (NSString*) tableName andClauses: (NSArray*) clauses; 

@end
